import pandas as pd
import numpy as np


df=pd.read_excel('task1_1.xlsx')
df=df.groupby(by='国家')['销售额'].sum()


df.to_excel('task1_1处理版.xlsx')




